Let's crunch some animal outcome data



In [ ]:

    
import pandas as pd

The read_csv() method supports loading data into a Data Frame directly from a URL link, so let's do that. It's a decent-sized file (74K rows).

Pro: This will get you the latest version of the data.

Con: Now your script requires an Internet connection.



In [ ]:

    
df = pd.read_csv('https://data.austintexas.gov/api/views/9t4d-g238/rows.csv')



In [ ]:

    
# run head() to check the output

df.head()



In [ ]:

    
# you can also use describe() to get a quick summary
# of the data in each column

df.describe()

Here are a couple to get us started:

What's the breakdown of animal type? (Cats, dogs, etc.)
What's the total intake volume by year?
What are the most common names for cats? For dogs? Broken down by year?
What percentage of dogs are euthanized every year? Adopted? Etc.
In 2016, what breeds of dogs were most likely to be euthanized? (Couple of ways to approach this question.)

What other questions do we have? Let's answer some of them together.

Extra credit 1: Send the results of your analysis to Slack.

Extra credit 2: Make a chart of your analysis.



In [ ]: